Release 10.1A: OpenEdge Data Management:
Database Administration

Database server performance parameters

Use the parameters listed in Table 18–1 to optimize server performance.

Table 18–1: Server performance parameters

Parameter	Syntax	Purpose
After-image Buffers	-aibufs n	Specifies the number of after-image buffers when running AIW.
After-image Stall	-aistall	Suspends database activity when an empty after-image (AI) file is unavailable.
Blocks in Database Buffers	-B n	Specifies the number of blocks in the database buffers.
Before-image Buffers	-bibufs n	Specifies the number of before-image buffers when running BIW.
Threshold Stall	-bistall	Quiets a database and sends a message to the log file when the recovery log threshold is reached. Use with -bithold.
Recovery Log Threshold	-bithold n	Specifies the maximum size of the recovery log files in MB.
Direct I/O	-directio	Opens all files in unbuffered mode.
Event Level	-evtlevel	Specifies the level of information written to the Windows Application Event Log.
Before-image Cluster Age	-G n	Specifies the number of seconds before the database reuses a before-image cluster.
Group Delay	-groupdelay n	Specifies the number of milliseconds a transaction waits before committing.
Hash Table Entries	-hash	Specifies the number of hash table entries for the buffer pool.
No Crash Protection	-i	Runs the database without integrity or recovery.
Lock Table Entries	-L n	Specifies the number of entries in the record locking table.
Delayed BI File Write	-Mf n	Delays writing the last before-image (BI) file records.
VLM Page Table Entry Optimization1	-Mpte	Allocates shared memory in multiples of 8MB for VLM64 support.
Shared-memory Overflow Size	-Mxs n	Replaces the default value of the shared-memory overflow area.
Number of Users	-n n	Specifies the maximum number of users connected to the database.
Pin Shared Memory	-pinshm	Prevents the OS from swapping shared memory contents to disk.
Semaphore Sets2	-semsets n	Changes the number of semaphore sets available to a broker.
Spin Lock Retries	-spin n	Specifies the number of times a process tries to acquire a latch before pausing.

1Compaq Tru64 only. 2UNIX only.